
clear all 

//define folder global here

gl Inputs "$folder\1_Inputs"
gl Intermediate "$folder\2_Intermediate"
gl Outputs "$folder\3_Outputs"

********************************************************************************

use "${Intermediate}\Combined for forloops.dta", clear

gen keeping = 1 if inlist(outcome, "lock", "move", "povr", "eshu", "home", "earn", "empl")
replace keeping = 1 if inlist(outcome, "inde", "cred", "zero", "deli", "auto", "hosp", "emer", "ment")
replace keeping = . if !inlist(time, "q0104", "q0508") 
keep if keeping==1 
drop keeping

keep if inlist(spec, "rf")

********************************************************************************
* DEFINE LOCALS THROUGH FOR LOOPS HERE
********************************************************************************
levelsof outcome, local(outcomes)
levelsof group, local(groups)
levelsof spec, local(specs)
levelsof time, local(times)
levelsof geo, local(geos)
levelsof item, local(items)

foreach outx in `outcomes' {
	local id1 = "`outx'"
	
	foreach grox in `groups' {
		local id2 = "`grox'"
		
		foreach spex in `specs' {
			local id3 = "`spex'"
			
			foreach timx in `times' {
				local id4 = "`timx'"
				
				foreach geox in `geos' {
					local id5 = "`geox'"
					
					foreach itex in `items' {
						local id6 = "`itex'"
		
					levelsof value if 	outcome=="`outx'" & ///
										group=="`grox'" & ///
										spec=="`spex'" & ///
										time=="`timx'" & ///
										geo=="`geox'" & ///
										item=="`itex'" , ///
						clean local(`id1'_`id2'_`id3'_`id4'_`id5'_`id6')
						di "`id1'_`id2'_`id3'_`id4'_`id5'_`id6'"
						
					}
				}
			}
		}
	}
}

gl x " "

********************************************************************************
********************************************************************************
**# TABLE H.10

texdoc init "${Outputs}/Supplementary data_Table_H10.tex", replace force 
tex {\footnotesize \begin{tabular}{l c c c c c} \hline \toprule ///
	& \multicolumn{2}{c}{\textbf{1 Year After Filing}} ///
	& & \multicolumn{2}{c}{\textbf{2 Years After Filing}} \\
	
tex \cmidrule{2-3} \cmidrule{5-6}
	
tex	& $ {\scriptsize \mathbb{E}[Y \vert E=0]}$ & RF ///
	& & $ {\scriptsize \mathbb{E}[Y \vert E=0]}$ & RF \\

tex & (1) & (2) & & (3) & (4) \\
tex \cmidrule{2-3} \cmidrule{5-6}

tex 					 	& & & & & \\

tex $x \textbf{Enforcement:} 	& `lock_a_rf_q0104_b_m' 		& `lock_a_rf_q0104_b_co' ///
							& & `lock_a_rf_q0508_b_m' 		& `lock_a_rf_q0508_b_co' \\ 
tex 						& `lock_a_rf_q0104_b_mse' 		& `lock_a_rf_q0104_b_se' ///
							& & `lock_a_rf_q0508_b_mse' 	& `lock_a_rf_q0508_b_se' \\	
tex $x 				 		& & \multicolumn{1}{c}{[`lock_a_rf_q0104_b_obs']} ///
							& & & \multicolumn{1}{c}{[`lock_a_rf_q0508_b_obs']} \\
									
tex $x \textit{By Location} 	& & & & & \\				
tex $x ~~~Cook County 		& `lock_a_rf_q0104_c_m' 		& `lock_a_rf_q0104_c_co'  ///
							& & `lock_a_rf_q0508_c_m' 		& `lock_a_rf_q0508_c_co'  \\ 
tex 						& `lock_a_rf_q0104_c_mse' 		& `lock_a_rf_q0104_c_se'  ///
							& & `lock_a_rf_q0508_c_mse' 	& `lock_a_rf_q0508_c_se'  \\ 				
tex $x ~~~New York 			& `lock_a_rf_q0104_n_m' 		& `lock_a_rf_q0104_n_co'  ///
							& & `lock_a_rf_q0508_n_m' 		& `lock_a_rf_q0508_n_co'  \\ 
tex 						& `lock_a_rf_q0104_n_mse' 		& `lock_a_rf_q0104_n_se'  ///
							& & `lock_a_rf_q0508_n_mse' 	& `lock_a_rf_q0508_n_se'  \\ 
tex $x \textit{By Group} 	& & & & & \\								
tex $x ~~~Female 			& `lock_f_rf_q0104_b_m' 		& `lock_f_rf_q0104_b_co'  ///
							& & `lock_f_rf_q0508_b_m' 		& `lock_f_rf_q0508_b_co'  \\ 
tex 						& `lock_f_rf_q0104_b_mse' 		& `lock_f_rf_q0104_b_se'  ///
							& & `lock_f_rf_q0508_b_mse' 	& `lock_f_rf_q0508_b_se'  \\ 			
tex $x ~~~Black  			& `lock_b_rf_q0104_b_m' 		& `lock_b_rf_q0104_b_co'  ///
							& & `lock_b_rf_q0508_b_m' 		& `lock_b_rf_q0508_b_co'  \\ 
tex 						& `lock_b_rf_q0104_b_mse' 		& `lock_b_rf_q0104_b_se'  ///
							& & `lock_b_rf_q0508_b_mse' 	& `lock_b_rf_q0508_b_se'  \\ 	
	
tex \midrule
tex 					 	& & & & & \\
tex $x \textbf{Not at eviction address:} 	& `move_a_rf_q0104_b_m' 		& `move_a_rf_q0104_b_co' ///
							& & `move_a_rf_q0508_b_m' 		& `move_a_rf_q0508_b_co' \\ 
tex 						& `move_a_rf_q0104_b_mse' 		& `move_a_rf_q0104_b_se' ///
							& & `move_a_rf_q0508_b_mse' 	& `move_a_rf_q0508_b_se' \\	
tex $x 				 		& & \multicolumn{1}{c}{[`move_a_rf_q0104_b_obs']} ///
							& & & \multicolumn{1}{c}{[`move_a_rf_q0508_b_obs']} \\
									
tex $x \textit{By Location} 	& & & & & \\				
tex $x ~~~Cook County 		& `move_a_rf_q0104_c_m' 		& `move_a_rf_q0104_c_co'  ///
							& & `move_a_rf_q0508_c_m' 		& `move_a_rf_q0508_c_co'  \\ 
tex 						& `move_a_rf_q0104_c_mse' 		& `move_a_rf_q0104_c_se'  ///
							& & `move_a_rf_q0508_c_mse' 	& `move_a_rf_q0508_c_se'  \\ 				
tex $x ~~~New York 			& `move_a_rf_q0104_n_m' 		& `move_a_rf_q0104_n_co'  ///
							& & `move_a_rf_q0508_n_m' 		& `move_a_rf_q0508_n_co'  \\ 
tex 						& `move_a_rf_q0104_n_mse' 		& `move_a_rf_q0104_n_se'  ///
							& & `move_a_rf_q0508_n_mse' 	& `move_a_rf_q0508_n_se'  \\ 
tex $x \textit{By Group} 	& & & & & \\								
tex $x ~~~Female 			& `move_f_rf_q0104_b_m' 		& `move_f_rf_q0104_b_co'  ///
							& & `move_f_rf_q0508_b_m' 		& `move_f_rf_q0508_b_co'  \\ 
tex 						& `move_f_rf_q0104_b_mse' 		& `move_f_rf_q0104_b_se'  ///
							& & `move_f_rf_q0508_b_mse' 	& `move_f_rf_q0508_b_se'  \\ 			
tex $x ~~~Black  			& `move_b_rf_q0104_b_m' 		& `move_b_rf_q0104_b_co'  ///
							& & `move_b_rf_q0508_b_m' 		& `move_b_rf_q0508_b_co'  \\ 
tex 						& `move_b_rf_q0104_b_mse' 		& `move_b_rf_q0104_b_se'  ///
							& & `move_b_rf_q0508_b_mse' 	& `move_b_rf_q0508_b_se'  \\ 	

							
tex \midrule 
tex 					 	& & & & & \\							
tex $x \textbf{Neighborhood poverty rate:} 	& `povr_a_rf_q0104_b_m' 		& `povr_a_rf_q0104_b_co' ///
							& & `povr_a_rf_q0508_b_m' 		& `povr_a_rf_q0508_b_co' \\ 
tex 						& `povr_a_rf_q0104_b_mse' 		& `povr_a_rf_q0104_b_se' ///
							& & `povr_a_rf_q0508_b_mse' 	& `povr_a_rf_q0508_b_se' \\	
tex $x 				 		& & \multicolumn{1}{c}{[`povr_a_rf_q0104_b_obs']} ///
							& & & \multicolumn{1}{c}{[`povr_a_rf_q0508_b_obs']} \\
									
tex $x \textit{By Location} 	& & & & & \\				
tex $x ~~~Cook County 		& `povr_a_rf_q0104_c_m' 		& `povr_a_rf_q0104_c_co'  ///
							& & `povr_a_rf_q0508_c_m' 		& `povr_a_rf_q0508_c_co'  \\ 
tex 						& `povr_a_rf_q0104_c_mse' 		& `povr_a_rf_q0104_c_se'  ///
							& & `povr_a_rf_q0508_c_mse' 	& `povr_a_rf_q0508_c_se'  \\ 				
tex $x ~~~New York 			& `povr_a_rf_q0104_n_m' 		& `povr_a_rf_q0104_n_co'  ///
							& & `povr_a_rf_q0508_n_m' 		& `povr_a_rf_q0508_n_co'  \\ 
tex 						& `povr_a_rf_q0104_n_mse' 		& `povr_a_rf_q0104_n_se'  ///
							& & `povr_a_rf_q0508_n_mse' 	& `povr_a_rf_q0508_n_se'  \\ 
tex $x \textit{By Group} 	& & & & & \\								
tex $x ~~~Female 			& `povr_f_rf_q0104_b_m' 		& `povr_f_rf_q0104_b_co'  ///
							& & `povr_f_rf_q0508_b_m' 		& `povr_f_rf_q0508_b_co'  \\ 
tex 						& `povr_f_rf_q0104_b_mse' 		& `povr_f_rf_q0104_b_se'  ///
							& & `povr_f_rf_q0508_b_mse' 	& `povr_f_rf_q0508_b_se'  \\ 			
tex $x ~~~Black  			& `povr_b_rf_q0104_b_m' 		& `povr_b_rf_q0104_b_co'  ///
							& & `povr_b_rf_q0508_b_m' 		& `povr_b_rf_q0508_b_co'  \\ 
tex 						& `povr_b_rf_q0104_b_mse' 		& `povr_b_rf_q0104_b_se'  ///
							& & `povr_b_rf_q0508_b_mse' 	& `povr_b_rf_q0508_b_se'  \\ 	
	
							
			
tex \bottomrule \\
tex	\end{tabular} }
texdoc close


********************************************************************************
********************************************************************************
**# TABLE H.11

texdoc init "${Outputs}/Supplementary data_Table_H11.tex", replace force 
tex {\footnotesize \begin{tabular}{l c c c c c} \hline \toprule ///
	& \multicolumn{2}{c}{\textbf{1 Year After Filing}} ///
	& & \multicolumn{2}{c}{\textbf{2 Years After Filing}} \\
	
tex \cmidrule{2-3} \cmidrule{5-6}
	
tex	& $ {\scriptsize \mathbb{E}[Y \vert E=0]}$ & RF ///
	& & $ {\scriptsize \mathbb{E}[Y \vert E=0]}$ & RF \\

tex & (1) & (2) & & (3) & (4) \\
tex \cmidrule{2-3} \cmidrule{5-6}

tex 					 	& & & & & \\

tex $x \textbf{Emergency shelter:} 	& `eshu_a_rf_q0104_b_m' 		& `eshu_a_rf_q0104_b_co' ///
							& & `eshu_a_rf_q0508_b_m' 		& `eshu_a_rf_q0508_b_co' \\ 
tex 						& `eshu_a_rf_q0104_b_mse' 		& `eshu_a_rf_q0104_b_se' ///
							& & `eshu_a_rf_q0508_b_mse' 	& `eshu_a_rf_q0508_b_se' \\	
tex $x 				 		& & \multicolumn{1}{c}{[`eshu_a_rf_q0104_b_obs']} ///
							& & & \multicolumn{1}{c}{[`eshu_a_rf_q0508_b_obs']} \\
									
tex $x \textit{By Location} 	& & & & & \\				
tex $x ~~~Cook County 		& `eshu_a_rf_q0104_c_m' 		& `eshu_a_rf_q0104_c_co'  ///
							& & `eshu_a_rf_q0508_c_m' 		& `eshu_a_rf_q0508_c_co'  \\ 
tex 						& `eshu_a_rf_q0104_c_mse' 		& `eshu_a_rf_q0104_c_se'  ///
							& & `eshu_a_rf_q0508_c_mse' 	& `eshu_a_rf_q0508_c_se'  \\ 				
tex $x ~~~New York 			& `eshu_a_rf_q0104_n_m' 		& `eshu_a_rf_q0104_n_co'  ///
							& & `eshu_a_rf_q0508_n_m' 		& `eshu_a_rf_q0508_n_co'  \\ 
tex 						& `eshu_a_rf_q0104_n_mse' 		& `eshu_a_rf_q0104_n_se'  ///
							& & `eshu_a_rf_q0508_n_mse' 	& `eshu_a_rf_q0508_n_se'  \\ 
tex $x \textit{By Group} 	& & & & & \\								
tex $x ~~~Female 			& `eshu_f_rf_q0104_b_m' 		& `eshu_f_rf_q0104_b_co'  ///
							& & `eshu_f_rf_q0508_b_m' 		& `eshu_f_rf_q0508_b_co'  \\ 
tex 						& `eshu_f_rf_q0104_b_mse' 		& `eshu_f_rf_q0104_b_se'  ///
							& & `eshu_f_rf_q0508_b_mse' 	& `eshu_f_rf_q0508_b_se'  \\ 			
tex $x ~~~Black  			& `eshu_b_rf_q0104_b_m' 		& `eshu_b_rf_q0104_b_co'  ///
							& & `eshu_b_rf_q0508_b_m' 		& `eshu_b_rf_q0508_b_co'  \\ 
tex 						& `eshu_b_rf_q0104_b_mse' 		& `eshu_b_rf_q0104_b_se'  ///
							& & `eshu_b_rf_q0508_b_mse' 	& `eshu_b_rf_q0508_b_se'  \\ 	
	
tex \midrule 
tex 					 	& & & & & \\
tex $x \textbf{Any homelessness services:} 	& `home_a_rf_q0104_b_m' 		& `home_a_rf_q0104_b_co' ///
							& & `home_a_rf_q0508_b_m' 		& `home_a_rf_q0508_b_co' \\ 
tex 						& `home_a_rf_q0104_b_mse' 		& `home_a_rf_q0104_b_se' ///
							& & `home_a_rf_q0508_b_mse' 	& `home_a_rf_q0508_b_se' \\	
tex $x 				 		& & \multicolumn{1}{c}{[`home_a_rf_q0104_b_obs']} ///
							& & & \multicolumn{1}{c}{[`home_a_rf_q0508_b_obs']} \\
									
tex $x \textit{By Location} 	& & & & & \\				
tex $x ~~~Cook County 		& `home_a_rf_q0104_c_m' 		& `home_a_rf_q0104_c_co'  ///
							& & `home_a_rf_q0508_c_m' 		& `home_a_rf_q0508_c_co'  \\ 
tex 						& `home_a_rf_q0104_c_mse' 		& `home_a_rf_q0104_c_se'  ///
							& & `home_a_rf_q0508_c_mse' 	& `home_a_rf_q0508_c_se'  \\ 				
tex $x ~~~New York 			& `home_a_rf_q0104_n_m' 		& `home_a_rf_q0104_n_co'  ///
							& & `home_a_rf_q0508_n_m' 		& `home_a_rf_q0508_n_co'  \\ 
tex 						& `home_a_rf_q0104_n_mse' 		& `home_a_rf_q0104_n_se'  ///
							& & `home_a_rf_q0508_n_mse' 	& `home_a_rf_q0508_n_se'  \\ 
tex $x \textit{By Group} 	& & & & & \\								
tex $x ~~~Female 			& `home_f_rf_q0104_b_m' 		& `home_f_rf_q0104_b_co'  ///
							& & `home_f_rf_q0508_b_m' 		& `home_f_rf_q0508_b_co'  \\ 
tex 						& `home_f_rf_q0104_b_mse' 		& `home_f_rf_q0104_b_se'  ///
							& & `home_f_rf_q0508_b_mse' 	& `home_f_rf_q0508_b_se'  \\ 			
tex $x ~~~Black  			& `home_b_rf_q0104_b_m' 		& `home_b_rf_q0104_b_co'  ///
							& & `home_b_rf_q0508_b_m' 		& `home_b_rf_q0508_b_co'  \\ 
tex 						& `home_b_rf_q0104_b_mse' 		& `home_b_rf_q0104_b_se'  ///
							& & `home_b_rf_q0508_b_mse' 	& `home_b_rf_q0508_b_se'  \\ 	
	
							
tex \bottomrule \\
tex	\end{tabular} }
texdoc close



********************************************************************************
********************************************************************************
**# TABLE H.12

texdoc init "${Outputs}/Supplementary data_Table_H12.tex", replace force 
tex {\footnotesize \begin{tabular}{l c c c c c} \hline \toprule ///
	& \multicolumn{2}{c}{\textbf{1-4 Quarters After Filing}} ///
	& & \multicolumn{2}{c}{\textbf{5-8 Quarters After Filing}} \\
	
tex \cmidrule{2-3} \cmidrule{5-6}
	
tex	& $ {\scriptsize \mathbb{E}[Y \vert E=0]}$  & RF ///
	& & $ {\scriptsize \mathbb{E}[Y \vert E=0]}$  & RF \\

tex & (1) & (2) & & (3) & (4) \\
tex \cmidrule{2-3} \cmidrule{5-6}

tex 					 	& & & & & \\
tex $x \textbf{Earnings:} 	& `earn_a_rf_q0104_b_m' 		& `earn_a_rf_q0104_b_co' ///
							& & `earn_a_rf_q0508_b_m' 		& `earn_a_rf_q0508_b_co' \\ 
tex 						& `earn_a_rf_q0104_b_mse' 		& `earn_a_rf_q0104_b_se' ///
							& & `earn_a_rf_q0508_b_mse' 	& `earn_a_rf_q0508_b_se' \\	
tex $x 				 		& & \multicolumn{1}{c}{[`earn_a_rf_q0104_b_obs']} ///
							& & & \multicolumn{1}{c}{[`earn_a_rf_q0508_b_obs']} \\
									
tex $x \textit{By Location} 	& & & & & \\				
tex $x ~~~Cook County 		& `earn_a_rf_q0104_c_m' 		& `earn_a_rf_q0104_c_co'  ///
							& & `earn_a_rf_q0508_c_m' 		& `earn_a_rf_q0508_c_co'  \\ 
tex 						& `earn_a_rf_q0104_c_mse' 		& `earn_a_rf_q0104_c_se'  ///
							& & `earn_a_rf_q0508_c_mse' 	& `earn_a_rf_q0508_c_se'  \\ 				
tex $x ~~~New York 			& `earn_a_rf_q0104_n_m' 		& `earn_a_rf_q0104_n_co'  ///
							& & `earn_a_rf_q0508_n_m' 		& `earn_a_rf_q0508_n_co'  \\ 
tex 						& `earn_a_rf_q0104_n_mse' 		& `earn_a_rf_q0104_n_se'  ///
							& & `earn_a_rf_q0508_n_mse' 	& `earn_a_rf_q0508_n_se'  \\ 
tex $x \textit{By Group} 	& & & & & \\								
tex $x ~~~Female 			& `earn_f_rf_q0104_b_m' 		& `earn_f_rf_q0104_b_co'  ///
							& & `earn_f_rf_q0508_b_m' 		& `earn_f_rf_q0508_b_co'  \\ 
tex 						& `earn_f_rf_q0104_b_mse' 		& `earn_f_rf_q0104_b_se'  ///
							& & `earn_f_rf_q0508_b_mse' 	& `earn_f_rf_q0508_b_se'  \\ 			
tex $x ~~~Black  			& `earn_b_rf_q0104_b_m' 		& `earn_b_rf_q0104_b_co'  ///
							& & `earn_b_rf_q0508_b_m' 		& `earn_b_rf_q0508_b_co'  \\ 
tex 						& `earn_b_rf_q0104_b_mse' 		& `earn_b_rf_q0104_b_se'  ///
							& & `earn_b_rf_q0508_b_mse' 	& `earn_b_rf_q0508_b_se'  \\ 	
	

tex \midrule 
tex 					 	& & & & & \\
tex $x \textbf{Employment:} 	& `empl_a_rf_q0104_b_m' 		& `empl_a_rf_q0104_b_co' ///
							& & `empl_a_rf_q0508_b_m' 		& `empl_a_rf_q0508_b_co' \\ 
tex 						& `empl_a_rf_q0104_b_mse' 		& `empl_a_rf_q0104_b_se' ///
							& & `empl_a_rf_q0508_b_mse' 	& `empl_a_rf_q0508_b_se' \\	
tex $x 				 		& & \multicolumn{1}{c}{[`empl_a_rf_q0104_b_obs']} ///
							& & & \multicolumn{1}{c}{[`empl_a_rf_q0508_b_obs']} \\
									
tex $x \textit{By Location} 	& & & & & \\				
tex $x ~~~Cook County 		& `empl_a_rf_q0104_c_m' 		& `empl_a_rf_q0104_c_co'  ///
							& & `empl_a_rf_q0508_c_m' 		& `empl_a_rf_q0508_c_co'  \\ 
tex 						& `empl_a_rf_q0104_c_mse' 		& `empl_a_rf_q0104_c_se'  ///
							& & `empl_a_rf_q0508_c_mse' 	& `empl_a_rf_q0508_c_se'  \\ 				
tex $x ~~~New York 			& `empl_a_rf_q0104_n_m' 		& `empl_a_rf_q0104_n_co'  ///
							& & `empl_a_rf_q0508_n_m' 		& `empl_a_rf_q0508_n_co'  \\ 
tex 						& `empl_a_rf_q0104_n_mse' 		& `empl_a_rf_q0104_n_se'  ///
							& & `empl_a_rf_q0508_n_mse' 	& `empl_a_rf_q0508_n_se'  \\ 
tex $x \textit{By Group} 	& & & & & \\								
tex $x ~~~Female 			& `empl_f_rf_q0104_b_m' 		& `empl_f_rf_q0104_b_co'  ///
							& & `empl_f_rf_q0508_b_m' 		& `empl_f_rf_q0508_b_co'  \\ 
tex 						& `empl_f_rf_q0104_b_mse' 		& `empl_f_rf_q0104_b_se'  ///
							& & `empl_f_rf_q0508_b_mse' 	& `empl_f_rf_q0508_b_se'  \\ 			
tex $x ~~~Black  			& `empl_b_rf_q0104_b_m' 		& `empl_b_rf_q0104_b_co'  ///
							& & `empl_b_rf_q0508_b_m' 		& `empl_b_rf_q0508_b_co'  \\ 
tex 						& `empl_b_rf_q0104_b_mse' 		& `empl_b_rf_q0104_b_se'  ///
							& & `empl_b_rf_q0508_b_mse' 	& `empl_b_rf_q0508_b_se'  \\ 	
	
							
tex \bottomrule \\
tex	\end{tabular} }
texdoc close



********************************************************************************
********************************************************************************
**# TABLE H.13

texdoc init "${Outputs}/Supplementary data_Table_H13.tex", replace force 
tex {\footnotesize \begin{tabular}{l c c c c c} \hline \toprule ///
	& \multicolumn{2}{c}{\textbf{1-4 Quarters After Filing}} ///
	& & \multicolumn{2}{c}{\textbf{5-8 Quarters After Filing}} \\
	
tex \cmidrule{2-3} \cmidrule{5-6}
	
tex	& $ {\scriptsize \mathbb{E}[Y \vert E=0]}$ & RF ///
	& & $ {\scriptsize \mathbb{E}[Y \vert E=0]}$ & RF \\

tex & (1) & (2) & & (3) & (4) \\
tex \cmidrule{2-3} \cmidrule{5-6}

tex 					 	& & & & & \\
tex $x \textbf{Financial health index:} 	& `inde_a_rf_q0104_b_m' 		& `inde_a_rf_q0104_b_co' ///
							& & `inde_a_rf_q0508_b_m' 		& `inde_a_rf_q0508_b_co' \\ 
tex 						& `inde_a_rf_q0104_b_mse' 		& `inde_a_rf_q0104_b_se' ///
							& & `inde_a_rf_q0508_b_mse' 	& `inde_a_rf_q0508_b_se' \\	
tex $x 				 		& & \multicolumn{1}{c}{[`inde_a_rf_q0104_b_obs']} ///
							& & & \multicolumn{1}{c}{[`inde_a_rf_q0508_b_obs']} \\
									
tex $x \textit{By Location} 	& & & & & \\				
tex $x ~~~Cook County 		& `inde_a_rf_q0104_c_m' 		& `inde_a_rf_q0104_c_co'  ///
							& & `inde_a_rf_q0508_c_m' 		& `inde_a_rf_q0508_c_co'  \\ 
tex 						& `inde_a_rf_q0104_c_mse' 		& `inde_a_rf_q0104_c_se'  ///
							& & `inde_a_rf_q0508_c_mse' 	& `inde_a_rf_q0508_c_se'  \\ 				
tex $x ~~~New York 			& `inde_a_rf_q0104_n_m' 		& `inde_a_rf_q0104_n_co'  ///
							& & `inde_a_rf_q0508_n_m' 		& `inde_a_rf_q0508_n_co'  \\ 
tex 						& `inde_a_rf_q0104_n_mse' 		& `inde_a_rf_q0104_n_se'  ///
							& & `inde_a_rf_q0508_n_mse' 	& `inde_a_rf_q0508_n_se'  \\ 	
tex \midrule 
tex 					 	& & & & & \\
tex $x \textbf{Credit score:} 	& `cred_a_rf_q0104_b_m' 		& `cred_a_rf_q0104_b_co' ///
							& & `cred_a_rf_q0508_b_m' 		& `cred_a_rf_q0508_b_co' \\ 
tex 						& `cred_a_rf_q0104_b_mse' 		& `cred_a_rf_q0104_b_se' ///
							& & `cred_a_rf_q0508_b_mse' 	& `cred_a_rf_q0508_b_se' \\	
									
tex $x \textit{By Location} 	& & & & & \\				
tex $x ~~~Cook County 		& `cred_a_rf_q0104_c_m' 		& `cred_a_rf_q0104_c_co'  ///
							& & `cred_a_rf_q0508_c_m' 		& `cred_a_rf_q0508_c_co'  \\ 
tex 						& `cred_a_rf_q0104_c_mse' 		& `cred_a_rf_q0104_c_se'  ///
							& & `cred_a_rf_q0508_c_mse' 	& `cred_a_rf_q0508_c_se'  \\ 				
tex $x ~~~New York 			& `cred_a_rf_q0104_n_m' 		& `cred_a_rf_q0104_n_co'  ///
							& & `cred_a_rf_q0508_n_m' 		& `cred_a_rf_q0508_n_co'  \\ 
tex 						& `cred_a_rf_q0104_n_mse' 		& `cred_a_rf_q0104_n_se'  ///
							& & `cred_a_rf_q0508_n_mse' 	& `cred_a_rf_q0508_n_se'  \\ 
tex \midrule 
tex 					 	& & & & & \\
tex $x \textbf{No open revolving account:} 	& `zero_a_rf_q0104_b_m' 		& `zero_a_rf_q0104_b_co' ///
							& & `zero_a_rf_q0508_b_m' 		& `zero_a_rf_q0508_b_co' \\ 
tex 						& `zero_a_rf_q0104_b_mse' 		& `zero_a_rf_q0104_b_se' ///
							& & `zero_a_rf_q0508_b_mse' 	& `zero_a_rf_q0508_b_se' \\	
									
tex $x \textit{By Location} 	& & & & & \\				
tex $x ~~~Cook County 		& `zero_a_rf_q0104_c_m' 		& `zero_a_rf_q0104_c_co'  ///
							& & `zero_a_rf_q0508_c_m' 		& `zero_a_rf_q0508_c_co'  \\ 
tex 						& `zero_a_rf_q0104_c_mse' 		& `zero_a_rf_q0104_c_se'  ///
							& & `zero_a_rf_q0508_c_mse' 	& `zero_a_rf_q0508_c_se'  \\ 				
tex $x ~~~New York 			& `zero_a_rf_q0104_n_m' 		& `zero_a_rf_q0104_n_co'  ///
							& & `zero_a_rf_q0508_n_m' 		& `zero_a_rf_q0508_n_co'  \\ 
tex 						& `zero_a_rf_q0104_n_mse' 		& `zero_a_rf_q0104_n_se'  ///
							& & `zero_a_rf_q0508_n_mse' 	& `zero_a_rf_q0508_n_se'  \\ 

tex \midrule 
tex 					 	& & & & & \\
tex $x \textbf{Total balance: collections and delinquencies:} 	& `deli_a_rf_q0104_b_m' 		& `deli_a_rf_q0104_b_co' ///
							& & `deli_a_rf_q0508_b_m' 		& `deli_a_rf_q0508_b_co' \\ 
tex 						& `deli_a_rf_q0104_b_mse' 		& `deli_a_rf_q0104_b_se' ///
							& & `deli_a_rf_q0508_b_mse' 	& `deli_a_rf_q0508_b_se' \\	

tex $x \textit{By Location} 	& & & & & \\				
tex $x ~~~Cook County 		& `deli_a_rf_q0104_c_m' 		& `deli_a_rf_q0104_c_co'  ///
							& & `deli_a_rf_q0508_c_m' 		& `deli_a_rf_q0508_c_co'  \\ 
tex 						& `deli_a_rf_q0104_c_mse' 		& `deli_a_rf_q0104_c_se'  ///
							& & `deli_a_rf_q0508_c_mse' 	& `deli_a_rf_q0508_c_se'  \\ 				
tex $x ~~~New York 			& `deli_a_rf_q0104_n_m' 		& `deli_a_rf_q0104_n_co'  ///
							& & `deli_a_rf_q0508_n_m' 		& `deli_a_rf_q0508_n_co'  \\ 
tex 						& `deli_a_rf_q0104_n_mse' 		& `deli_a_rf_q0104_n_se'  ///
							& & `deli_a_rf_q0508_n_mse' 	& `deli_a_rf_q0508_n_se'  \\ 
	
tex \midrule 
tex 					 	& & & & & \\
tex $x \textbf{Any auto loan or lease:} 	& `auto_a_rf_q0104_b_m' 		& `auto_a_rf_q0104_b_co' ///
							& & `auto_a_rf_q0508_b_m' 		& `auto_a_rf_q0508_b_co' \\ 
tex 						& `auto_a_rf_q0104_b_mse' 		& `auto_a_rf_q0104_b_se' ///
							& & `auto_a_rf_q0508_b_mse' 	& `auto_a_rf_q0508_b_se' \\	
									
tex $x \textit{By Location} 	& & & & & \\				
tex $x ~~~Cook County 		& `auto_a_rf_q0104_c_m' 		& `auto_a_rf_q0104_c_co'  ///
							& & `auto_a_rf_q0508_c_m' 		& `auto_a_rf_q0508_c_co'  \\ 
tex 						& `auto_a_rf_q0104_c_mse' 		& `auto_a_rf_q0104_c_se'  ///
							& & `auto_a_rf_q0508_c_mse' 	& `auto_a_rf_q0508_c_se'  \\ 				
tex $x ~~~New York 			& `auto_a_rf_q0104_n_m' 		& `auto_a_rf_q0104_n_co'  ///
							& & `auto_a_rf_q0508_n_m' 		& `auto_a_rf_q0508_n_co'  \\ 
tex 						& `auto_a_rf_q0104_n_mse' 		& `auto_a_rf_q0104_n_se'  ///
							& & `auto_a_rf_q0508_n_mse' 	& `auto_a_rf_q0508_n_se'  \\ 
							
tex \bottomrule \\
tex	\end{tabular} }
texdoc close



********************************************************************************
********************************************************************************
**# TABLE H.14

texdoc init "${Outputs}/Supplementary data_Table_H14.tex", replace force 
tex {\footnotesize \begin{tabular}{l c c c c c} \hline \toprule ///
	& \multicolumn{2}{c}{\textbf{1-4 Quarters After Filing}} ///
	& & \multicolumn{2}{c}{\textbf{5-8 Quarters After Filing}} \\
	
tex \cmidrule{2-3} \cmidrule{5-6}
	
tex	& $ {\scriptsize \mathbb{E}[Y \vert E=0]}$ & RF ///
	& & $ {\scriptsize \mathbb{E}[Y \vert E=0]}$ & RF \\

tex & (1) & (2) & & (3) & (4) \\
tex \cline{2-3} \cline{5-6}

tex 						& & & & & \\
tex $x Number of hospital visits 	& `hosp_a_rf_q0104_n_m' 		& `hosp_a_rf_q0104_n_co'  ///
							& & `hosp_a_rf_q0508_n_m' 		& `hosp_a_rf_q0508_n_co'  \\
tex							& `hosp_a_rf_q0104_n_mse' 		& `hosp_a_rf_q0104_n_se' 	///
							& & `hosp_a_rf_q0508_n_mse' 		& `hosp_a_rf_q0508_n_se'  \\

tex 						& & & & & \\
tex $x Number of emergency visits	& `emer_a_rf_q0104_n_m' 		& `emer_a_rf_q0104_n_co'  ///
							& & `emer_a_rf_q0508_n_m' 		& `emer_a_rf_q0508_n_co' 	\\
tex							& `emer_a_rf_q0104_n_mse' 		& `emer_a_rf_q0104_n_se' ///
							& & `emer_a_rf_q0508_n_mse' 		& `emer_a_rf_q0508_n_se' \\

tex 						& & & & & \\
tex $x Number of mental health visits 	& `ment_a_rf_q0104_n_m' 		& `ment_a_rf_q0104_n_co' 	///
							& & `ment_a_rf_q0508_n_m' 		& `ment_a_rf_q0508_n_co' 	 \\
tex							& `ment_a_rf_q0104_n_mse' 		& `ment_a_rf_q0104_n_se' 	 ///
							& & `ment_a_rf_q0508_n_mse' 		& `ment_a_rf_q0508_n_se' 	 \\
tex $x 				 		& & \multicolumn{1}{c}{[`ment_a_rf_q0104_n_obs']} & ///
							& & \multicolumn{1}{c}{[`ment_a_rf_q0508_n_obs']} \\	


tex \bottomrule \\
tex	\end{tabular} }
texdoc close
